EMT Practice Test

1. Question Content...

---

Question1: A large government organization mandates that all departments establish an equivalent data presence in a standby data center.
Which technology should the GIS database administrator recommend?

Question2: An organization using ArcGIS Enterprise needs to make a map with 10 million features viewable in ArcGIS Online. The data must be kept up to date from an enterprise geodatabase.
Which replication option should the GIS administrator use?

Question3: A GIS database administrator needs to identify any performance issues with a nightly load process. Upon further research, the database administrator discovers the following:
* A table with 20 million rows is reloaded each night
* This existing table is truncated before an Append is executed
* There are three attributes in addition to objectid and geometry, one of which is a unique text identifier
* The unique index is removed before Append and created again after Append
* The Append operation takes 120 minutes to complete
What should the administrator recommend?

Question4: A GIS administrator receives reports of slowing performance across the entire geodatabase. Users report that the time for edits to be made and drawing are affected when adding 10.000 records. Traditional versioning is being used.
The following processes are completed weekly:
* Rebuilding of indexes and statistics
* Geodatabase compress
* Remove orphaned connections
Which action should be taken?

Question5: An organization needs to reduce the number of RDBMS users. ArcGIS Enterprise and ArcGIS Pro are implemented. Editors need to isolate edits and ensure that edits are reviewed before becoming public.
Which editing model should the GIS administrator implement?

Question6: A telecommunications company implements branch versioning for their organization. The default version is the published version that portal users see and editors can post edits to.
Which version access level should be set?

Question7: An enterprise geodatabase is regularly updated via a "push" batch SQL process from a federated database.
Business rules prevent a one-to-one match in the values in INSERT values for one field. The GIS administrator must make sure that the attribute value in the geodatabase is populated correctly. Which option should the administrator use?

Question8: AGIS data manager realizes that archiving cannot be enabled for a feature class. An investigation reveals that the problem is in the feature class configuration.
How was the feature class registered?

Question9: AGIS analyst who usesArcGIS Pro needs to reload data into a versioned feature class stored in a feature dataset. The feature class participates in a geodatabase topology.
Which steps should the GIS analyst take?

Question10: A user creates a database view of a feature class and then registers the view with the geodatabase.
How does registering benefit users?

Question11: A GIS data administrator is creating database connection files for all editors. For security reasons, the database connection files must point to the edit version for the user.
Which catalog option should be used?

Question12: An editor connects to an enterprise geodatabase to edit a feature class that uses traditional versioning. The editor uses the following workflow:
* The Default version is set lo protected
* A new child version is created from Default
* The child version is set to protected
* Edits are saved to the child version
* The editor tries to reconcile and post to Default
The reconcile is successful, but the post operation fails with an error. What should the editor do?

Question13: ArcGIS Pro users must be able to use the Undo and Redo buttons while editing a dataset. At the same time, SQL users must be able to edit this dataset.
How should the ArcGIS data administrator configure this dataset?

Question14: A GIS data administrator needs to load a large amount of data into a version, verify its quality, and then reconcile and post this version to default. The data administrator needs to create the fewest number of rows in the database.
Which versioning method should be used?

Question15: A database administrator needs to move the enterprise geodatabase to a new server. The new enterprise geodatabase must be kept intact.
Which process should be used?

Question16: A GIS analyst creates a database view. When the database view is loaded into the map, performance is suboptimal.
Which workflow should the analyst use?

Question17: AGIS data manager realizes that archiving cannot be enabled for a feature class. An investigation reveals that the problem is in the feature class configuration.
How was the feature class registered?

Question18: A GIS analyst needs to track feature class changes and keep the reconcile, post, and compress processes separate from the replica synchronization process.
What should the analyst do?

Question19: A user wants to share a frequently edited points feature class as a web layer. The points contain sensitive attributes and will be read-only for online viewers.
The following workflow is applied:
* Points is registered as versioned
* A standard database view is created for points, which hides the sensitive attributes
* The view is published as a web layer from the Default version
As the points feature class is edited throughout the week, edits are not visible in the web layer.
What should the GIS administrator do?

Question20: A GIS administrator needs to convert an existing database into a geodatabase. The new database has been created, but the repository owner has not been created. The GIS administrator has been given the database administrator credentials for this conversion to a geodatabase.
Which tool should the GIS administrator use?

Question21: The GIS administrator does not have the database administrator credentials and needs to create an enterprise geodatabase for storage of vector data. The database administrator will provide a database with the appropriate users and permissions for use.
Which tool should the GIS administrator use?

Question22: A GIS data administrator frequently changes the map based on definition queries. A noticeable lag occurs when changing the parameter value of the definition query.
Which action should be taken?

Question23: A GIS data manager observes that editors spend multiple hours resolving conflicts when they reconcile.
* Conflicts are detected by attribute
* Traditional versioning is being used
* The geodatabase is being compressed weekly
* Versions are reconciled and posted weekly
Which change will result in fewer conflicts?

Question24: A user in an organization is granted read/write access to the data. The user saves the username and password in a connection file for convenience. This user creates layer files that save visualization properties and organizes them in folders on the server for the viewers to access.
Which issue is caused by this workflow?

Question25: A GIS administrator receives reports that users are unable to connect to the geodatabase after nightly maintenance. The GIS administrator can successfully connect.
What should the administrator check for?

Question26: An editor is loading records from a shapefile to a feature class that is registered as versioned using the following workflow:
* Create a child version from Default
* Append 500,000 records while connected to the child version
* Reconcile and post the child version to Default
The reconcile is taking a long time to complete.
What is causing this issue?

Question27: A GIS data administrator needs to store color, model, and size attributes for different kinds of valves. Pick lists should only show permitted combinations of color, model, and size.
Which geodatabase capability should be configured?

Question28: An organization needs to distribute data to a regional office. The regional office does not have ArcGIS Enterprise orArcGIS Online accounts. The regional office also does not have access to an enterprise geodatabase.
Which data distribution solution should be used?

Question29: A GIS administrator needs to simultaneously grant access for multiple users of a branch versioned feature class in an enterprise geodatabase.
How should permissions be granted?

Question30: A GIS administrator creates a SQL command to update values in a feature class. In a test environment, the command is run against the feature class table. All the values do not seem to get updated.
Which configuration is causing this issue?